views get 'lost' - Mailing list pgsql-general

From Christoph Pingel
Subject views get 'lost'
Date
Msg-id a06100501be326e6d87f9@[62.224.55.11]
Whole thread Raw
List pgsql-general
I'm still quite new to postgres, struggeling with 'views'... I'm on
OS X, using aquadatastudio to interface the db.

Now, after issuing a 'CREATE VIEW' command, I get back a '1 record
affected' message, and I can use the view. However, the view doesn't
appear in the tree view of aquadatastudio (even after reconnecting),
and after restarting postgresql, it's lost. I used to think that
'CREATE VIEW...' is all I have to do, am I wrong?

TIA,
Christoph

pgsql-general by date:

Previous
From: Terry Lee Tucker
Date:
Subject: Re: a few doubts regarding postgres
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Understanding EXPLAIN ANALYZE output